The CSA_tweets database holds the starter-stakeholders data and their first - degree tie information. There are 27 starter-stakeholders, or users whose accounts are used to start the data collection process. The CSA_tweets database has the following structure (in addition to a substantial amount of other data which is reviewed in later sections).
The majority of the starter-stakeholders are CSA’s though not all. There are several major broker users in the network. These are users who help promote and advocate for small-holder argriculture and sustainable/organic food systems. An example of one broker in the starter-stakeholders group is the CSANetwork.
The table below details the general structure of the data after a bit of processing is done. We first pull the user’s screen name and their tweets. Then, we pull all the mentioned users from the tweet (names that start with the ‘@’ symbol). We then create one row for each distinct screen name, tweet and mentioned screen name. This forms a natural edgelist that is used to make the network graphs. The tweets, which connect the screen names and the mentioned screen names, can be analysed using text mining (natural language process, sentiment analysis, etc.)
| screen_name | text | mentions_screen_name |
|---|---|---|
| turriefield | @DunkeldField It breaks up by end of season but has done its job by then, and remnants go on the compost | DunkeldField |
| FCFCGWales |
Exciting role with @swanseacommfarm, the deadline for the Finance & Resource Officer post has been extended to Wednesday 10th April, 11.59pm. #CommunityFarm #FinanceandResource https://t.co/QVPHe6I1gB |
swanseacommfarm |
| waterlanderman | CSA veg picked, packed and ready to go to @ZedifyCBG for delivery @sustcambridge @TransitionCambs https://t.co/QmuuhTXaN6 | ZedifyCBG |
| SuttonFarm | Look at this gorgeous salad going out to our restaurant customers every week! We are looking for new restaurants to work with so please get in touch if you would like to join @HIXRestaurants @eatnativeuk @PlumSpiltMilk many others in championing local produce? https://t.co/xIO5vSEy8S | HIXRestaurants |
| turriefield | @1999Smallhold Kale pesto? | 1999Smallhold |
We have collected 7,367 tweets from starting stakeholders.
On average, starter-stakeholders tweet about 9.47 times per week. Though some tweet, on average, as many as 43 and some as low as 1. The figure below shows the number of tweets per week for each starting-stakeholder. The figure is interactive, and a guide is shown in the upper right-hand corner.
We started pulling down tweets on the 12th week in 2019, early March. There is a great deal of varibility of number of tweets for each starter-stakeholders. Some, like Rmarketgarden have tweeted a total of 3 times since data collection started. Others are quite prolific tweeters, with LoveYourVeg having tweeted 334 times since data collection started. Some variability in number of tweets can be explained by whether or not the starter-stakeholder is a information broker or not. Brokers tend to tweet much more often.Most of the starker-stakeholders are located in England, with about 62.1%. Scotland is second with about 20.7%. There are three in Wales and one in Northern Ireland. Some locations are shown in the map below.